select count(CoverageId),CoverageId, ClubId, BusinessClassId, BusinessTypeId
 from glcoverageapplicable
group by CoverageId, ClubId, BusinessClassId, BusinessTypeId
HAVING COUNT(CoverageId) >1

select * from GLCoverageApplicable where CoverageId = 287 and ClubId = 150

 --deactiveyn like 'N'
select count(*) from GLCoverageApplicable 
group by ClubId, BusinessClassId, BusinessTypeId



select * from GLCoverage where CoverageId = 287
select * from GLClub-- where cluid
SELECT * FROM ColumbusAdm.LookupCombination where ClubName like 'AM 2'

Select  lc.LookupCategoryName + ' -- ' + l.LookupName
FROM GLLookup l INNER join GLLookupCategory lc ON l.LookupCategoryId = lc.LookupCategoryId
where l.LookupName LIKE '%[%]%'
and l.DeactiveYN = 'N'
ORDER BY lc.LookupCategoryName 